create sequence p1_seq
nocache
create sequence p2_seq
nocache

create sequence generator_seq
nocache

create table generator(
generate number(5),
result number(5)
);

create table p1(
p1 number(5),
result number(5)
);
create table p1seq(
p1seq number(5)
);
INSERT INTO p1seq VALUES('1');


create table p2(
p2 number(5),
result number(5)
);
create table p2seq(
p2seq number(5)
);
INSERT INTO p2seq VALUES('1');


select * from generator
select * from P1SEQ;
select * from P2SEQ;
drop table generator;
drop table p1;
drop table p2;
drop table p1seq;
drop table p2seq;
drop sequence generator_seq;
select * from p1
select generator_seq.nextVal from dual
select p2_seq.nextVal from dual

drop sequence p1_seq
drop sequence p2_seq					  
